pendiente Neo4j Medlab

Original en la caja: hetzbox:archivo/lengua/terminologia-salud/medlab-neo4j/pendiente Neo4j Medlab.txt · fecha del fichero: 2019-02-14 18:18 · formato original: .txt · convertido el 21/10/2026 13:03 (E-1154 · Karb and Sil).

MATCH (n) WHERE EXISTS(n.code_ctaem1) RETURN DISTINCT labels(n) as entity

["VDM_code_index"] ["VDM_product_ctaem1"] ["VDM_ctaem2"] ["VDM_package_ctaem2"]

create index on :VDM_code_index(code_ctaem1) create index on :VDM_product_ctaem1(code_ctaem1) create index on :VDM_ctaem2(code_ctaem1) create index on :VDM_package_ctaem2(code_ctaem1)

MATCH ()-[r]-() WHERE EXISTS(r.code_ctaem1) RETURN DISTINCT TYPE(r)

MATCH p=()-[r:VademecumRelationship]->() where r.code_ctaem1 is not null RETURN p LIMIT 25

create index on :VademecumRelationship(code_ctaem1)

Conectando: ["VDM_package_ctaem2"]

match (n:ObjectConcept), (m:VDM_package_ctaem2) where n.sctid = toString(m.code_ctaem1) CREATE (n)-[r:VDM_paackage_ctaem2_ctaem1_To_Object_Concept_sctid{ name: n.sctid + '<->' + m.code_ctaem1}]->(m) return n.sctid,m.code_ctaem1 Ha tardado como 56 horas Ha creado 21.000 Relaciones

Conectar primero el Vademecum entre sí: ["VDM_package_ctaem2"] -> ["VDM_code_index"]

match (n:VDM_package_ctaem2)-[:VDM_paackage_ctaem2_ctaem1_To_Object_Concept_sctid]->(::ObjectConcept), (m:VDM_code_index{code_ctaem1:n.code_ctaem1}) CREATE (n)-[r:VDM_code_index_ctaem1_To_VDM_code_index_ctaem1{ name: n.code_ctaem1}]->(m) return count(n)

Por conectar: ["VDM_code_index"]

match (n:ObjectConcept)- [ObjectConcept_sctid_To_VDM_package_ctaem2_ctaem1]->(m:VDM_package_ctaem2)- [VDM_code_index_ctaem1_To_VDM_code_index_sctid]->(o) CREATE (n)-[r:VDM_code_index_ctaem1_To_Object_Concept_sctid{ name: n.sctid}]->(o) return count(n)

Por conectar: ["VDM_product_ctaem1"]

Match (n:VDM_package_ctaem2)-[:VDM_paackage_ctaem2_ctaem1_To_Object_Concept_sctid]-(o:ObjectConcept), (n)-[r:VademecumRelationship{code_ctaem1:n.code_ctaem1}]-(m:VDM_product_ctaem1) CREATE (o)-[:ObjectConcept_sctid_To_VDM_product_ctaem1_ctaem1{name: n.code_ctaem1}]->(m) return count(r)

match (n:VDM_package_ctaem2), (m:VDM_product_ctaem1) where n.code_ctaem1 = m.code_ctaem1 CREATE (n)-[r:VDM_code_index_ctaem1_To_VDM_VDM_product_ctaem1_ctaem1{ name: n.code_ctaem1}]->(m) return count(n)

["VDM_product_ctaem1"]

["VDM_ctaem2"] Match (n:VDM_package_ctaem2)-[:VDM_paackage_ctaem2_ctaem1_To_Object_Concept_sctid]-(o:ObjectConcept), (n)-[r:VademecumRelationship{code_ctaem1:n.code_ctaem1}]-(m:VDM_ctaem2) CREATE (o)-[:ObjectConcept_sctid_To_VDM_package_ctaem2_ctaem1{name: n.code_ctaem1}]->(m) return count(r) Conectados 21.066 nodos en 2 segundos

Otros nodos a conectar: Allergy: allergy_snomed_id/Allergy_snomed_name Molecule: molecule_snomed_id/Molecule_snomed_name

chown -R neo4j:neo4j graph.db/

MATCH (n:ObjectConcept) SET n.sctid_Int = toInteger(n.sctid_Int) RETURN count(n)

match (a)-[r:VademecumRelationship]-(b) where r.code_ctaem1 is not null return r, labels(a), labels(b) limit 100

profile Match (n:VDM_package_ctaem2)-[:VDM_paackage_ctaem2_ctaem1_To_Object_Concept_sctid]->(o:ObjectConcept), (n)-[r:VademecumRelationship{code_ctaem1=n.code_ctaem1}]-(m:VDM_code_index) CREATE (m)-[r:VDM_code_index_ctaem1_To_ObjectConcept_sctid{name: n.code_ctaem1}]->(o) return count(n)

Match (n:VDM_package_ctaem2)-[:VDM_paackage_ctaem2_ctaem1_To_Object_Concept_sctid]-(o:ObjectConcept), (n)-[r:VademecumRelationship{code_ctaem1:n.code_ctaem1}]-(m:VDM_ctaem2) CREATE (o)-[r:ObjectConcept_sctid_To_VDM_package_ctaem2_ctaem1{name: n.code_ctaem1}]->(m) return count(r)

Nodos conectados por match (n:VDM_package_ctaem2)-[:VademecumRelationship{code_ctaem1:n.code_ctaem1}]-(m) return count(m) , labels(m)

MATCH (n)-[r:VDM_paackage_ctaem2_ctaem1_To_Object_Concept_sctid]->(m) merge (n)-[s:VDM_package_ctaem2_ctaem1_To_Object_Concept_sctid{name:n.code_ctaem1}]->(m) RETURN count(s)

IMPORTANTES Vademecum español

match (m:VDM_package_ctaem2), (n:ObjectConcept {sctid_Int:m.code_ctaem1}) CREATE (n)-[r:VDM_package_ctaem2_ctaem1_To_Object_Concept_sctid{ name: n.sctid_Int}]->(m) return n.sctid,m.code_ctaem1

match (m:VDM_code_index), (n:ObjectConcept {sctid_Int:m.code_ctaem1}) MERGE (n)-[r:VDM_code_index_ctaem1_To_Object_Concept_sctid{ name: n.sctid_Int}]->(m) return n.sctid,m.code_ctaem1

match (m:VDM_product_ctaem1), (n:ObjectConcept {sctid_Int:m.code_ctaem1}) MERGE (n)-[r:VDM_product_ctaem1_To_Object_Concept_sctid{ name: n.sctid_Int}]->(m) return n.sctid,m.code_ctaem1

match (m:VDM_ctaem2), (n:ObjectConcept {sctid_Int:m.code_ctaem1}) MERGE (n)-[r:VDM_ctaem2_To_Object_Concept_sctid{ name: n.sctid_Int}]->(m) return n.sctid,m.code_ctaem1

VDM_allergy match (m:VDM_allergy), (n:ObjectConcept {sctid_Int:m.allergysnomedid}) MERGE (n)-[r:VDM_allergy_To_Object_Concept_sctid{ name: n.sctid_Int}]->(m) return n.sctid,m.allergysnomedid

molecule_snomed_id match (m:VDM_molecule), (n:ObjectConcept {sctid_Int:m.moleculesnomedid}) MERGE (n)-[r:VDM_molecule_To_Object_Concept_sctid{ name: n.sctid_Int}]->(m) return n.sctid,m.moleculesnomedid

CONSULTAS

MATCH (n:VDM_package),(m:VDM_code_index) WHERE n.packageid=m.packageid and n.name CONTAINS 'DILTIAZEM' RETURN n.name,m.commonnamegroupid